Example: Database Table

The table from the database will be added as a dataset. The fields and rows in this dataset will be determined by the query that you entered or generated.

Table in database:

Configuration:

Provider: Microsoft OLE DB Provider for SQL Server (SQLOLEDB)

Server: Server1

Database: Data Preparation

Selected table: Table1

Selected fields: Field 1, Field2, Field3, Field4

Query:

SELECT [Field1], [Field2], [Field3], [Field4]

FROM [dbo].[Table1]

WHERE [Field1] IS NOT NULL

Resulting dataset:

---

Related topics:

• Overview of operation: Database table

• Configuring operation: Database table

• Overview of operations

• Technical comparison of operations

• Overview of icons